﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Data.SqlClient;

namespace DAL
{
    public class WXfriendsService
    {
        private static String ConServerStr = @" Data Source=bds249611391.my3w.com;Initial Catalog=bds249611391_db;Persist Security Info=True;User ID=bds249611391;Password=hq312453";
        SqlConnection conn = new SqlConnection(ConServerStr);

        public void CreateTable(string UserName)
        {
            string Name = "WXfriends" + UserName;
            string sql = "use bds249611391_db"
                + " create table WXfriends"+ UserName
                +" ("
                + " WXfriendsId int not null identity(1,1),"
                + " FriendNumber int not null,"
                + " )"
                + " use bds249611391_db"
                + " alter table "+Name
                + " ";
        }
        
    }
}
